Copy report subscriptions

The SBS Upgrade Package includes a tool that copies the old system report subscriptions. However, since report subscriptions in IONESPMPME are handled differently depending on which SQL Server edition is used, the tool does not work for certain SQL server edition upgrade scenarios.

SQL Server Edition	Scheduling Tool	Configuration UI	Schedule Details
SQL Standard	SQL Agent	Report Management UI in Web Applications	Stored in msdb database (part of SQL Server)
SQL Express	ION Task Scheduler	Report Management UI in Web Applications	Stored in ION_Network database

Use the following information to determine which upgrade process to use:

IONE 6.0.1 SPM 7.0.1 PME 7.2.2 PME 8.2	PME 8.2	Upgrade Process
SQL Standard	SQL Standard	Use SBS Upgrade Package tool (see instructions below)
SQL Express	SQL Standard	Use SBS Upgrade Package tool (see instructions below)
SQL Standard	SQL Express	Subscriptions must be recreated in PME (skip this topic)
SQL Express	SQL Express	Subscriptions are automatically transferred with the ION_Network database migration (skip this topic)

Distributed System Note: Complete these tasks on the Application Server.

To copy the report subscriptions:

1. In the ...\SBS Upgrade Package\Report_Subscriptions folder, locate ExportSubscriptions.exe and IONSubscriptionsHelper.dll.
2. Copy the 2 files to the ...\ION Enterprise\system\bin...\Power Monitoring Expert\system\bin folder on the old ION EnterpriseStruxureWare Power MonitoringPME system.
3. As the Administrator, run ExportSubscriptions.exe.

   The tool opens a command prompt and indicates when the task is complete.

   

   The output of the tool is a file called ...\ION Enterprise\system\bin...\Power Monitoring Expert\system\bin\IONSubscriptionData.xml.

4. Press Enter to close the command prompt window.
5. Copy IONSubscriptionData.xml to the ...\SBS Upgrade Package\Report_Subscriptions\ folder.